--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.

--##SECTION BEGIN [INTERNAL STORED PROCS]

--This SQL is generated for internal stored procedures for table [Category]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Category_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Category_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Category_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Category_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Category_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Category_Update]
GO

--This SQL is generated for internal stored procedures for table [Customer]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Customer_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Customer_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Customer_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Customer_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Customer_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Customer_Update]
GO

--This SQL is generated for internal stored procedures for table [Employee]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Employee_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Employee_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Employee_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Employee_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Employee_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Employee_Update]
GO

--This SQL is generated for internal stored procedures for table [EmployeeTerritory]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_EmployeeTerritory_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_EmployeeTerritory_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_EmployeeTerritory_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_EmployeeTerritory_Insert]
GO

--This SQL is generated for internal stored procedures for table [Order]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Order_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Order_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Order_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Order_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Order_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Order_Update]
GO

--This SQL is generated for internal stored procedures for table [OrderDetail]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_OrderDetail_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_OrderDetail_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_OrderDetail_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_OrderDetail_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_OrderDetail_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_OrderDetail_Update]
GO

--This SQL is generated for internal stored procedures for table [Product]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Product_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Product_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Product_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Product_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Product_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Product_Update]
GO

--This SQL is generated for internal stored procedures for table [Region]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Region_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Region_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Region_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Region_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Region_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Region_Update]
GO

--This SQL is generated for internal stored procedures for table [Shipper]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Shipper_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Shipper_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Shipper_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Shipper_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Shipper_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Shipper_Update]
GO

--This SQL is generated for internal stored procedures for table [Supplier]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Supplier_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Supplier_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Supplier_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Supplier_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Supplier_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Supplier_Update]
GO

--This SQL is generated for internal stored procedures for table [SystemUser]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_SystemUser_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_SystemUser_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_SystemUser_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_SystemUser_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_SystemUser_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_SystemUser_Update]
GO

--This SQL is generated for internal stored procedures for table [Territory]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Territory_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Territory_Delete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Territory_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Territory_Insert]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gen_Territory_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[gen_Territory_Update]
GO

--##SECTION END [INTERNAL STORED PROCS]

